load data
truncate
into table CRST_PER_ALL_POSITIONS
fields terminated by "	"
trailing nullcols 
( POSITION_ID                ,
  BUSINESS_GROUP_ID          ,
  JOB_ID                     ,
  ORGANIZATION_ID            ,
  SUCCESSOR_POSITION_ID      ,
  RELIEF_POSITION_ID         ,
  LOCATION_ID                ,
  POSITION_DEFINITION_ID     ,
  DATE_EFFECTIVE             Date 'YYYYMMDD HH24:MI:SS',
  COMMENTS                   ,
  DATE_END                   Date 'YYYYMMDD HH24:MI:SS',
  FREQUENCY                  ,
  NAME                       ,
  PROBATION_PERIOD           ,
  PROBATION_PERIOD_UNITS     ,
  REPLACEMENT_REQUIRED_FLAG  ,
  TIME_NORMAL_FINISH         ,
  TIME_NORMAL_START          ,
  WORKING_HOURS              ,
  REQUEST_ID                 ,
  PROGRAM_APPLICATION_ID     ,
  PROGRAM_ID                 ,
  PROGRAM_UPDATE_DATE        Date 'YYYYMMDD HH24:MI:SS',
  ATTRIBUTE_CATEGORY         ,
  ATTRIBUTE1                 ,
  ATTRIBUTE2                 ,
  ATTRIBUTE3                 ,
  ATTRIBUTE4                 ,
  ATTRIBUTE5                 ,
  ATTRIBUTE6                 ,
  ATTRIBUTE7                 ,
  ATTRIBUTE8                 ,
  ATTRIBUTE9                 ,
  ATTRIBUTE10                ,
  ATTRIBUTE11                ,
  ATTRIBUTE12                ,
  ATTRIBUTE13                ,
  ATTRIBUTE14                ,
  ATTRIBUTE15                ,
  ATTRIBUTE16                ,
  ATTRIBUTE17                ,
  ATTRIBUTE18                ,
  ATTRIBUTE19                ,
  ATTRIBUTE20                ,
  STATUS                     ,
  OBJECT_VERSION_NUMBER      ,
  LAST_UPDATE_DATE           Date 'YYYYMMDD HH24:MI:SS',
  LAST_UPDATED_BY            ,
  LAST_UPDATE_LOGIN          ,
  CREATED_BY                 ,
  CREATION_DATE              Date 'YYYYMMDD HH24:MI:SS'
)